/**
 *
 */
package io.gitee.falllee.dao.model;

/**
 * @author batty
 * @date 2020-09-13
 *
 */
public class FormatConstant {

    private FormatConstant() {
    }

    public static final String COMMA = ",";

    public static final String COMMA_WITH_QUOTATION = "','";

    public static final String SPACE_TWO = "%s %s";

    public static final String AND = " and ";

    public static final String OR = " or ";

    public static final String LIKE = "%s like CONCAT('%%', %s, '%%')";

    public static final String NOT_LIKE = "%s not like CONCAT('%%', %s, '%%')";

    public static final String LEFT_LIKE = "%s like CONCAT('%%', %s)";

    public static final String NOT_LEFT_LIKE = "%s not like CONCAT('%%', %s)";

    public static final String RIGHT_LIKE = "%s like CONCAT(%s, '%%')";

    public static final String NOT_RIGHT_LIKE = "%s not like CONCAT(%s, '%%')";

    public static final String REGEXP = "%s regexp %s";

    public static final String EQUAL = "%s = %s";

    public static final String EQUAL_WITH_RIGHT_QUOTATION = "%s = '%s'";

    public static final String UNEQUAL = "%s != %s";

    public static final String UNEQUAL_WITH_RIGHT_QUOTATION = "%s != '%s'";

    public static final String GREATER_THEN = "%s > %s";

    public static final String GREATER_THEN_WITH_RIGHT_QUOTATION = "%s > '%s'";

    public static final String GREATER_OR_EQUAL = "%s >= %s";

    public static final String GREATER_OR_EQUAL_WITH_RIGHT_QUOTATION = "%s >= '%s'";

    public static final String LESS_THEN = "%s < %s";

    public static final String LESS_THEN_WITH_RIGHT_QUOTATION = "%s < '%s'";

    public static final String LESS_OR_EQUAL = "%s <= %s";

    public static final String LESS_OR_EQUAL_WITH_RIGHT_QUOTATION = "%s <= '%s'";

    public static final String BETWEEN_AND = "%s BETWEEN %s AND %s";

    public static final String BETWEEN_AND_WITH_RIGHT_QUOTATION = "%s BETWEEN '%s' AND '%s'";

    public static final String IN = "%s in (%s)";
    
    public static final String NOT_IN = "%s not in (%s)";

    public static final String IN_WITH_RIGHT_QUOTATION = "%s IN ('%s')";

    public static final String BRACKETS = "(%s)";

    public static final String AND_TWO = "%s and %s";

    public static final String DATE_FORMAT_WITH_GT = "DATE_FORMAT(%s, '%%Y-%%m-%%d') > '%s'";

    public static final String DATE_FORMAT_WITH_GTE = "DATE_FORMAT(%s, '%%Y-%%m-%%d') >= '%s'";

    public static final String DATE_FORMAT_WITH_LT = "DATE_FORMAT(%s, '%%Y-%%m-%%d') < '%s'";

    public static final String DATE_FORMAT_WITH_LTE = "DATE_FORMAT(%s, '%%Y-%%m-%%d') <= '%s'";

    public static final String OR_TWO =  "%s or %s  ";

    public static final String COUNT_FUNC = " count(*) %s";

    public static final String IS_NULL = "%s is null";

    public static final String IS_NOT_NULL = "%s is not null";

    public static final String OTHER_TABLE_FIELD_WHERE = "%s in (select %s from %s where %s)";

    public static final String ASC = "asc";

    public static final String DESC = "desc";
    
    public static final String TABLE_FIELD_WHERE = "select %s from %s where %s";
    
    public static final String TABLE_FIELD = "select %s from (%s) s";

    public static final String OR_TWO_BRACKETS =  " ( %s or %s  ) ";

    public static final String JSON_CONTAINS = "JSON_CONTAINS(%s, %s)";

}
